Previous Topic

Next Topic

Enhancements to query filters

The following enhancements have been made to query filters:

Comparisons

Values

Prompts

In this release of iMIS, the labels used for Prompt types have been made more intuitive.

Old Label

New Label

No

No

Yes

Optional

Yes*

Required

The functionality of the Optional (Yes) prompt type has also been changed. Previously, an Optional filter could be left blank only on the first run of a query. If you tried to re-run the query again, you were forced to choose a value, and you had to completely reload the query if you wanted to leave the Optional filter blank. In this release, however, a new -All- value appears in an Optional filter field after the first run of a query, which has the same effect as leaving the filter field blank.

Query Options

A new Limit the number of results returned checkbox, visible in the Query Options section when in Advanced Mode, enables you to specify a limit to the number of rows that can be returned by the query. By setting the corresponding Prompt to No, you make the specified value a hard limit for the query. By setting the Prompt to Optional or Required, you make the specified value a default that can be overridden by users when they run the query. When coupled with sort criteria, this filter can effect a "top n records" type of result. See Limiting the rows returned by a query for more information.

In This Section

Limiting the rows returned by a query

Defining multiple values for a filter property

See Also

IQA changes

New Advanced Query links and personalized query links

New ability to link to iMIS modules from query results

New ability to specify more than 500 returned rows

Changes to IQA security


ASI logo 10.6 Production Release. Updated 3/6/2006 9:57:51 AM
© Copyright by Advanced Solutions International, Inc. All rights reserved.